CDISC Builder™  2.1 - Installation Test Scripts - %ordervar
The following documentation contains test scripts and expected results for validating the CDISC Builder tool.  Do the following to verify proper installation:
  • Perform each test by performing the steps specified by the instructions.  
  • Evaluate the results of each step by comparing them with results described in the Documentation column. 
Script Description Documentation
ordervar1.sas Test the condition where the required parameters are missing. Instructions 1

ordervar1.log

ordervar2.sas Test the condition where the parameters: data, rdomain, key  are invalid. Instructions 2

ordervar2.log

ordervar3.sas   Test the condition where the parameter basecode is invalid. Instructions 3

ordervar3.log

ordervar4.sas       Test condition where the variable domain and parameter rdomain are missing.   Instructions 4
ordervar4.log
ordervar4.sas7bdat
ordervar5.sas   Test condition where the variable domain is missing.   Instructions 5
ordervar5.log
ordervar5.sas7bdat
ordervar6.sas Test condition where the parameter rdomain is missing.  

Instructions 6
ordervar6.log
ordervar6.sas7bdat

ordervar7.sas Test condition where the key parameters are not continuous.  

Instructions 7
ordervar7.log

ordervar8a.sas
ordervar8b.sas 		Verify that base code is generated.

Instructions 8
o_basecode8a.sas
o_basecode8b.sas

ordervar9.sas Verify if the application brought back to the stored path. Instructions 9
ordervar_gui.sas Test the condition if the stored path has been removed.  Instructions 10
none Verify input Source Data manually. Instructions 11
none Test the condition when information is not refreshed after input Source Data manually. Instructions 12
none Test the condition where Data Sets list is empty. Instructions 13
none Test the condition where Variables list is empty. Instructions 14
none Test the condition where source data set does not contains DOMAIN variable and Related Domain field is missing. Instructions 15
none Verify invalid path and filename in Base code field when input manually. Instructions 16
none Verify when the data is locked or opened by SAS Viewer can not be opened for update. Instructions 17
none Verify the Keys exceed the maximum of 10. Instructions 18
none Test Save Code function. Instructions 19
save_ordervar19.sas

Instructions 1
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation directory named "saspgm".

  2. Right mouse click on ordervar1.sas and select "Batch Submit".

  3. Review the ordervar1.log and verify that the following message is produced:


    • ERROR: [ordervar] is missing required parameter DATA. 

Instructions 2
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation directory named "saspgm".

  2. Right mouse click on ordervar2.sas and select "Batch Submit".

  3. Review the ordervar2.log and verify that the following messages are produced corresponding to each test.

    • ERROR: [ordervar] has an invalid dataset: xyz. 

    • ERROR: [ordervar] The domain must be in ( 
      'AE', 'AU', 'BM', 'BR', 'CM', 'CO', 'CP', 
      'DC', 'DM', 'DR', 'DS', 'DV', 'DY', 'EE', 
      'EG', 'EX', 'FH', 'HU', 'IE', 'IM', 'LB', 
      'MB', 'MH', 'ML', 'NE', 'OM', 'PC', 'PE', 
      'PP', 'QS', 'SC', 'SE', 'SG', 'SK', 'SL', 
      'SS', 'ST', 'SU', 'SV', 'TA', 'TE', 'TI', 
      'TV', 'VS'). 

    • ERROR: [ordervar] was not able to find key: xyz

Instructions 3
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation directory named "saspgm".

  2. Right mouse click on ordervar3.sas and select "Batch Submit".

  3. Review the ordervar3.log and verify that the following messages are produced corresponding to each test.

    • ERROR: [ordervar] The base code path 'z:\invalid' does not exist.

    • ERROR: [ordervar] The base code file must be SAS file.

Instructions 4
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the data directory named "saspgm\data\ordervar".

  2. Open dataset 'ordervar4' and verify there is no variable 'domain'.

  3. Navigate to the validation directory named "saspgm".

  4. Right mouse click on ordervar4.sas and select "Batch Submit".

  5. Review the ordervar4.log and verify that there is no error message and 1 warning message as the following:

    • WARNING: [ordervar] Both variable and parameter DOMAIN are missing.

  6. Navigate to the data directory named "data\ordervar".

  7. Open dataset 'odervar4' and verify that there is variable 'domain' with blank value. Verify that dataset variables positions (except key variable) are sorted order.

Instructions 5
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the data directory named "data\ordervar".

  2. Open dataset 'ordervar5' and verify there is no variable 'domain'.

  3. Navigate to the validation directory named "saspgm".

  4. Right mouse click on ordervar5.sas and select "Batch Submit".

  5. Review the ordervar5.log and verify that there is no error message and warning message.

  6. Open dataset 'order5' and verify that there is variable 'domain' with value "AE". Verify that dataset variables positions (except key variable) are sorted order.

Instructions 6
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the data directory named "data\ordervar".

  2. Open dataset 'ordervar6' and verify there is variable 'domain' and dataset variables positions are not sorted order.

  3. Navigate to the validation directory named "saspgm".

  4. Right mouse click on ordervar6.sas and select "Batch Submit".

  5. Review the ordervar6.log and verify that there is no error message and warning message.

  6. Navigate to the data directory named "data\ordervar".

  7. Open dataset 'order6' and verify that dataset variables positions are sorted order.

Instructions 7
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation directory named "saspgm".

  2. Right mouse click on ordervar7.sas and select "Batch Submit".

  3. Review the ordervar7.log and verify that there's 1 error message as the following:

    • ERROR: [ordervar] Key parameters must be continuous.

Instructions 8
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the data directory named "data\ordervar".

  2. Open dataset 'ordervar8' and verify there's no variable domain.

  3. Navigate to the "saspgm" folder.

  4. Right mouse click on ordervar8a.sas and select "Batch Submit".

  5. Review the ordervar8a.log and verify that there is no error message and warning message.

  6. Verify that file o_basecode8a.sas is generated.

  7. Navigate to the data directory named "data\ordervar".

  8. Open dataset 'ordervar8' and verify that there's variable 'domain' with value "AE". Verify that data row is sorted by key variable and then original sort order. Verify that dataset variables positions (except key variables) are sorted order.

  9. Navigate to the "saspgm" folder.

  10. Right mouse click on ordervar8b.sas and select "Batch Submit".

  11. Review the ordervar8b.log and verify that there is no error message.

  12. Verify that file o_basecode8b.sas is generated.

  13. Navigate to the data directory named "data\ordervar".

  14. Verify that all datasets have variable 'domain'. Verify that data row is sorted by key variable and then original sort order. Verify that dataset variables positions (except key variables) are sorted order.

  15. Copy all datasets (except dataset 'ae' and 'novar') from the folder 'Original' to the current directory.

  16. Copy o_basecode8b.sas to a directory (such as "c:\temp").

  17. Right mouse click on o_basecode8b.sas and select "Batch Submit".

  18. Navigate to the data directory named "data\ordervar".

  19. Verify that all datasets have variable 'domain'. Verify that data row is sorted by key variable and then original sort order. Verify that dataset variables positions (except key variables) are sorted order.

Instructions 9
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation sub-directory named "saspgm".

  2. Right mouse click on the ordervar9.sas program and select "Batch Submit".

  3. The "ORDERVAR - Order Variables by Key and Alphabetical" screen is displayed.

  4. Verify default value of Source Data is current directory.

  5. Click on [...] button to navigate to the validation sub-directory named "data\ordervar".  Click OK button to select this path.

  6. Data Sets list all datasets that locate in "data\ordervar" directory.

  7. Click "Cancel" button to close the application. Batch Submit "ordervar_gui.sas".

  8. Verify that Source Data brings the selected path of the last time and Data Sets list lists datasets that locate in this path.

Instructions 10
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation sub-directory named "saspgm".

  2. Right mouse click on the ordervar_gui.sas program and select "Batch Submit".

  3. Select path for Source Data field that navigates to the directory of "data\ordervar".

  4. Click "Cancel" button.

  5. Rename "ordervar" folder to "ordervar_temp".

  6. Right mouse click on "cdiscgui.sas".

  7. Right mouse click on "cdiscgui.sas" again and verify that the path in Source Data now is of current directory.

  8. Rename "ordervar_temp" folder to "ordervar".

Instructions 11
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation sub-directory named "saspgm".

  2. Right mouse click on the cdiscgui.sas program and select "Batch Submit".

  3. The "ORDERVAR - Order Variables by Key and Variable" screen is displayed.

  4. In this screen, clear values in Source Data field and hit enter.

  5. A warning message appears:
    WARNING: The field (Source Data) contains a missing value.

  6. Input a path for Source Data that does not exist and hit Enter, another message is displayed:
    WARNING: The field (Source Data) contains non-existing directory.

  7. Type a path that navigates to "data\ordervar" sub-directory such as:
    C:\temp\ordervar_test\testing\data\Ordervar and hit Enter.

  8. Verify the Data Sets list lists all data in this path.

Instructions 12
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation sub-directory named "saspgm".

  2. Right mouse click on the cdiscgui.sas program and select "Batch Submit".

  3. The "ORDERVAR - Order Variables by Key and Variable" screen is displayed.

  4. Clear values in Source Data field and click "OK" button.

  5. A warning message appears:
    WARNING: The field (Source Data) contains a missing value.

  6. Input a path that does not exist in Source Data and click "OK", another message is displayed:
    WARNING: The field (Source Data) contains non-existing directory.

  7. Type a path that navigates to "data\ordervar" sub-directory such as:
    C:\temp\ordervar_test\testing\data\Ordervar 

  8. Do not hit enter.  Click on the "OK" button.

  9. Verify that there is a message as follow:
    WARNING: You have not confirmed your change of Source Data to your system. 

  10. Close that message box and hit enter.

  11. Verify the Data Sets list is refreshed and lists all data in this path.

Instructions 13
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation sub-directory named "saspgm".

  2. Right mouse click on the cdiscgui.sas program and select "Batch Submit".

  3. The "ORDERVAR - Order Variables by Key and Variable" screen is displayed.

  4. Input a path that does not contains any SAS datasets for Source Data field.

  5. Verify the Data Sets list is empty.

  6. Click "OK" button.

  7. A warning message appears:
    WARNING: The Data Sets list is empty.

  8. Click "OK" to close that message box.

  9. Click "Cancel" to out application.

Instructions 14
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the data-directory named "data\ordervar".

  2. Copy all datasets (except dataset 'ae' and 'novar') from the folder ' Original' to the current directory.

  3. Navigate to the validation sub-directory named "saspgm".

  4. Right mouse click on the cdiscgui.sas program and select "Batch Submit".

  5. The "ORDERVAR - Order Variables by Key and Variable" screen is displayed.

  6. Select path for Source Data field that navigates to the directory of "data\ordervar".

  7. Verify the Data Sets list lists all SAS datasets in this folder.

  8. Select "NOVAR" dataset in Data Sets list

  9. Verify there are no variables displayed in Variables list.

  10. Click "OK" button.

  11. A warning message appears:
    WARNING: The NOVAR dataset does not contain any variables.

  12. Click "OK" to close that message box.

  13. Click "Cancel" to out application.

Instructions 15
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation sub-directory named "saspgm".

  2. Right mouse click on the cdiscgui.sas program and select "Batch Submit".

  3. The "ORDERVAR - Order Variables by Key and Variable" screen is displayed.

  4. Select path for Source Data field that navigates to the directory of "data\ordervar".

  5. Select "AE" dataset in Data Sets list

  6. Verify variables of AE dataset are displayed in Variables list and there is not variable named "DOMAIN".

  7. Click "OK" button.

  8. A warning message appears:
    WARNING: The field (Related Domain) contains a missing value.

  9. Click "OK" to close that message box.

  10. Click "Cancel" to out application.

Instructions 16
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation sub-directory named "saspgm".

  2. Right mouse click on the cdiscgui.sas program and select "Batch Submit".

  3. The "ORDERVAR - Order Variables by Key and Variable" screen is displayed.

  4. Select path for Source Data field that navigates to the directory of "data\ordervar".

  5. Select "AE" dataset in Data Sets list

  6. Verify variables of AE dataset are displayed in Variables list and there is not variable named "DOMAIN".

  7. Select "AE - Adverse Events" for Related Domain field.

  8. Input Base code this value "c:\noexit\test.sas".

  9. Click "OK", the following message appears:
    WARNING: The field (Base Code) contains an invalid directory.

  10. Type "c:\temp\test.test", and click "OK" again.  A warning message box is displayed:
    WARNING: The field (Base Code) contains an invalid sas file name.

  11. Click Cancel button to end the program.

Instructions 17
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation sub-directory named "saspgm".

  2. Right mouse click on the cdiscgui.sas program and select "Batch Submit".

  3. The "ORDERVAR - Order Variables by Key and Variable" screen is displayed.

  4. Input the following information:
    Source Data: (path that navigate to "data\ordervar")
    Data Sets list: AE
    Related Domain: AE - Adverse Events

  5. Navigate to "data\ordervar" and open "AE" dataset.

  6. Come back the application and click "OK" button.

  7. Verify a message box is displayed as follow:
    WARNING: The existing source dataset (AE) is not available to be updated.

  8. Click "OK" to close that message box.

  9. Click "Cancel" to out application.

Instructions 18
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation sub-directory named "saspgm".

  2. Right mouse click on the cdiscgui.sas program and select "Batch Submit".

  3. The "ORDERVAR - Order Variables by Key and Variable" screen is displayed.

  4. Input the following information:
    Source Data: (path that navigate to "data\ordervar")
    Data Sets list: AE

  5. In Variables list, select 10 variables and click '>>' button.

  6. Verify the Keys list lists all selected variables.

  7. Select another variable in Variables list and click button '>>' again.

  8. A message box is displayed as follow:
    WARNING: The Keys list contains a number of variables that exceeds the maximum of 10.

  9. Click "OK" to close that message box.

  10. Click "Cancel" to out application.

Instructions 19
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation sub-directory named "saspgm".

  2. Right mouse click on the cdiscgui.sas program and select "Batch Submit".

  3. The "ORDERVAR - Order Variables by Key and Variable" screen is displayed.

  4. Input information for this screen as follow:
    Source Data: path that navigate to "data\ordervar" validation directory.
    Data Sets: AE.
    Keys list: PTID, ONSTDT1
    Related Domain: AE - Adverse Events.
    Base code: c:\temp\ordervar_ae_base.sas

  5. Click on the "Save Code..." button to open "Save Code" screen.

  6. Verify that Path contains the current directory.

  7. Type "save_ordervar19" in Filename and then click the "OK" button.

  8. The program shows "save_ordervar19.sas" contains code that has been saved in editor and this can be verified against the "save_ordervar19.sas" found in the benchmark area.

  9. Close the program and open "ordervargui.log" to verify that there is no error message generated.

For more information, please contact MXI .

 
     Meta-Xceed Inc. © 2009